Tabela ServiceAutorisation

Definicja tabeli ServiceAutorisation

Name

ServiceAutorisation

Code

ServiceAutorisation

Comment

 


Lista kolumn tabeli ServiceAutorisation

Name

Code

ServID

ServID

PersonnelTypeID

PersonnelTypeID

Number

Number

UniqueItem

UniqueItem

SystemText

SystemText


Kolumna ServID tabeli ServiceAutorisation

Definicja kolumny ServID tabeli ServiceAutorisation

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonnelTypeID tabeli ServiceAutorisation

Definicja kolumny PersonnelTypeID tabeli ServiceAutorisation

Name

PersonnelTypeID

Code

PersonnelTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Number tabeli ServiceAutorisation

Definicja kolumny Number tabeli ServiceAutorisation

Name

Number

Code

Number

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UniqueItem tabeli ServiceAutorisation

Definicja kolumny UniqueItem tabeli ServiceAutorisation

Name

UniqueItem

Code

UniqueItem

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna SystemText tabeli ServiceAutorisation

Definicja kolumny SystemText tabeli ServiceAutorisation

Name

SystemText

Code

SystemText

Data Type

VARCHAR2(512)

Mandatory

No

Comment

Opis reguly autoryzacji


Lista kluczy tabeli ServiceAutorisation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ServiceAutorisation

Definicja klucza Identifier_1 tabeli ServiceAutorisation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment